OLAP Data Cube - Dimension editor

Report viewers can manipulate the dimensions of an OLAP cube at run time. The dimension editor allows you to specify the caption, forecasting method, visibility, and filtering for each dimension. When you apply a filter to a dimension at run time, the button for that dimension changes color. If at least one value in the dimension is set to a filtered state (Set to filtered state button. Looks like a paper with a red x.) then the dimension button will be green. If the items are only set to invisible (Set to invisible button. Looks like a paper with a blue X.) then the dimension button will be blue.

The Dimention editor with Department entered into the Caption field.   The list of dimension values is displayed, each with a green check in its asociated check box.

Dimension Editor Tools

Icon Description
green eye Visible: The dimension value appears in the cube and is included in the calculated measures.
slashed blue eye Invisible: The dimension value does not appear in the cube, but data for this value is included in the calculated measures.
Red slashed circle Filtered: The dimension value does not appear in the cube, and is not included in the calculated measures.
Toggle dimension state button. Looks like the double circular refresh. Toggle dimension state: visible -> invisible -> filtered -> visible.
Add hierarchy group button. Looks like a folder with a green plus. Add hierarchy group. A hierarchy group allows you to group similar values together.
Delete hierarchy group button. Looks like a folder with a red x. Delete hierarchy group.
Expand and collapse tree nodes button. Expand/collapse tree nodes.
Sort dimensions in the specified order button. Looks like shuffled papers. Sort dimensions in the specified order.
Accept changes and close button. Looks like a green checkmark. Accept changes and close screen.
Cancel changes and close screen button. Looks like a red x. Cancel changes and close screen.
Open help button. Looks like a blue question mark. Open Help.

 


Need More Help?

If you need additional help creating OLAP Cubes, refer to Getting Started with OLAP Cubes.